<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Spring boot Mybatis | actors</title>
<!-- Tell the browser to be responsive to screen width -->
<meta
	content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"
	name="viewport">
<!-- Bootstrap 3.3.7 -->
<link rel="stylesheet"
	href="bower_components/bootstrap/dist/css/bootstrap.min.css">
<!-- Font Awesome -->
<link rel="stylesheet"
	href="bower_components/font-awesome/css/font-awesome.min.css">
<!-- Ionicons -->
<link rel="stylesheet"
	href="bower_components/Ionicons/css/ionicons.min.css">
<!-- jvectormap -->
<link rel="stylesheet"
	href="bower_components/jvectormap/jquery-jvectormap.css">
<!-- bootgrid -->
<link rel="stylesheet" href="dist/css/jquery.bootgrid.min.css" />
<!-- bootstrap datepicker -->
<link rel="stylesheet" href="bower_components/bootstrap-datepicker/dist/css/bootstrap-datepicker.min.css">
<!-- Theme style -->
<link rel="stylesheet" href="dist/css/AdminLTE.min.css">
<!-- AdminLTE Skins. Choose a skin from the css/skins
       folder instead of downloading all of them to reduce the load. -->
<link rel="stylesheet" href="dist/css/skins/_all-skins.min.css">

<!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
  <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
  <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
  <![endif]-->

<!-- Google Font -->
<link rel="stylesheet" href="dist/css/fonts.googleapis.com.css">
</head>
<body class="hold-transition skin-blue sidebar-mini fixed">
	<div class="wrapper">

		<header class="main-header">

			<!-- Logo -->
			<a href="index2.html" class="logo"> <!-- mini logo for sidebar mini 50x50 pixels -->
				<span class="logo-mini"><b>A</b>LT</span> <!-- logo for regular state and mobile devices -->
				<span class="logo-lg"><b>Spring boot </b>Mybatis</span>
			</a>

			<!-- Header Navbar: style can be found in header.less -->
			<nav class="navbar navbar-static-top">
				<!-- Sidebar toggle button-->
				<a href="#" class="sidebar-toggle" data-toggle="push-menu"
					role="button"> <span class="sr-only">Toggle navigation</span>
				</a>
				<!-- Navbar Right Menu -->
				<div class="navbar-custom-menu">
					<ul class="nav navbar-nav">


						<!-- User Account: style can be found in dropdown.less -->
						<li class="dropdown user user-menu"><a href="#"
							class="dropdown-toggle" data-toggle="dropdown"> <img
								src="dist/img/user2-160x160.jpg" class="user-image"
								alt="User Image"> <span class="hidden-xs username">
								</span>
						</a>
							<ul class="dropdown-menu">
								<!-- User image -->
								<li class="user-header"><img
									src="dist/img/user2-160x160.jpg" class="img-circle"
									alt="User Image">

									<p>
										Alexander Pierce - Web Developer <small>Member since
											Nov. 2012</small>
									</p></li></li>
						<!-- Menu Footer-->
						<li class="user-footer">

							<div class="pull-right">
								<a href="logout" class="btn btn-default btn-flat">Sign out</a>
							</div>
						</li>
					</ul>
					</li>
					<!-- Control Sidebar Toggle Button -->
					<li><a href="#" data-toggle="control-sidebar"><i
							class="fa fa-gears"></i></a></li>
					</ul>
				</div>

			</nav>
		</header>
		<!-- Left side column. contains the logo and sidebar -->
		<aside class="main-sidebar">
			<!-- sidebar: style can be found in sidebar.less -->
			<section class="sidebar">
				<!-- Sidebar user panel -->
				<div class="user-panel">
					<div class="pull-left image">
						<img src="dist/img/user2-160x160.jpg" class="img-circle"
							alt="User Image">
					</div>
					<div class="pull-left info">
						<p class="username">Alexander Pierce</p>
						<a href="#"><i class="fa fa-circle text-success"></i> Online</a>
					</div>
				</div>

				<!-- sidebar menu: : style can be found in sidebar.less -->
				<ul class="sidebar-menu" data-widget="tree">
					<li class="header">MAIN NAVIGATION</li>
					<li class="active treeview menu-open"><a href="#"> <i
							class="fa fa-dashboard"></i> <span>演员表</span> <span
							class="pull-right-container"> <i
								class="fa fa-angle-left pull-right"></i>
						</span>
					</a>
						<ul class="treeview-menu">
							<li class="active"><a href="showactor"><i
									class="fa fa-circle-o"></i> actors</a></li>
						</ul></li>
					<li class="treeview"><a href="#"> <i class="fa fa-edit"></i>
							<span>国家与城市表</span> <span class="pull-right-container"> <i
								class="fa fa-angle-left pull-right"></i>
						</span>
					</a>
						<ul class="treeview-menu">
							<li><a href="city"><i
									class="fa fa-circle-o"></i> 展示各国家城市列表</a></li>
							<li><a href="country"><i
									class="fa fa-circle-o"></i> 展示中国的城市列表</a></li>

						</ul></li>

					<li><a href="fileupload"> <i
							class="fa fa-calendar"></i> <span>文件上传</span>

					</a></li>
					<li><a href="analysis"> <i
							class="fa fa-pie-chart"></i> <span>统计分析</span>
					</a></li>

				</ul>
			</section>
			<!-- /.sidebar -->
		</aside>

		<!-- Content Wrapper. Contains page content -->
		<div class="content-wrapper">
			<!-- Content Header (Page header) -->
			<section class="content-header">
				<h1>
					演员列表 <small>单表查询</small>
				</h1>
				<ol class="breadcrumb">
					<li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
					<li class="active">演员表</li>
				</ol>
			</section>

			<!-- Main content -->
			<section class="content">
				<!-- Info boxes -->
				<div class="row">
					<!-- Main row -->
					<div class="row">
						<!-- Left col -->
						<div class="col-md-12">
							<!-- TABLE: LATEST ORDERS -->
							<div class="box box-info">
								<div class="box-header with-border">
									<h3 class="box-title">Actor Lists</h3>

									<div class="box-tools pull-right">
										<button type="button" class="btn btn-box-tool"
											data-widget="collapse">
											<i class="fa fa-minus"></i>
										</button>
										<button type="button" class="btn btn-box-tool"
											data-widget="remove">
											<i class="fa fa-times"></i>
										</button>
									</div>
								</div>
								<!-- /.box-header -->
								<div class="box-body">
									<div class="table-responsive">
										<table id="grid-data"
											class="table table-condensed table-hover table-striped">
											<thead>
												<tr>
													<th data-column-id="actor_id" data-identifier="true"
														data-type="numeric">ID</th>
													<th data-column-id="first_name">first_name</th>
													<th data-column-id="last_name">last_name</th>
													<th data-column-id="last_update" data-order="desc">last_update</th>
													<th data-column-id="commands" data-formatter="commands"
														data-sortable="false">modify</th>
												</tr>
											</thead>
										</table>
									</div>
									<!-- /.table-responsive -->
								</div>
								<!-- /.box-body -->
								<div class="box-footer clearfix">
									<a href="javascript:void(0)"
										class="btn btn-sm btn-info btn-flat pull-left"
										data-toggle="modal" data-target="#modal-info">添加一个演员</a> 
									<a href="javascript:void(0)"
										class="btn btn-sm btn-warning btn-flat pull-left"
										data-toggle="modal" data-target="#excel-info">导入演员Excel数据</a> 
									<a onclick="downloadByPost()" class="btn btn-sm btn-danger btn-flat pull-right">导出数据为Excel</a>
								</div>
								
								<!-- /.box-footer -->
							</div>
							<!-- /.box -->
						</div>
						<!-- /.col -->


					</div>
					<!-- /.row -->
			</section>
			<!-- /.content -->
		</div>
		<!-- /.content-wrapper -->

		<footer class="main-footer">
			<div class="pull-right hidden-xs">
				<b>Version</b> 2.4.18
			</div>
			<strong>Copyright &copy; 2014-2019 <a
				href="https://adminlte.io">AdminLTE</a>.
			</strong> All rights reserved.
		</footer>

		<!-- Control Sidebar -->
		<aside class="control-sidebar control-sidebar-dark">
			<!-- Create the tabs -->
			<ul class="nav nav-tabs nav-justified control-sidebar-tabs">
				<li><a href="#control-sidebar-home-tab" data-toggle="tab"><i
						class="fa fa-home"></i></a></li>
				<li><a href="#control-sidebar-settings-tab" data-toggle="tab"><i
						class="fa fa-gears"></i></a></li>
			</ul>
			<!-- Tab panes -->
			<div class="tab-content">
				<!-- Home tab content -->
				<div class="tab-pane" id="control-sidebar-home-tab">
					<h3 class="control-sidebar-heading">Recent Activity</h3>
					<ul class="control-sidebar-menu">
						<li><a href="javascript:void(0)"> <i
								class="menu-icon fa fa-birthday-cake bg-red"></i>

								<div class="menu-info">
									<h4 class="control-sidebar-subheading">Langdon's Birthday</h4>

									<p>Will be 23 on April 24th</p>
								</div>
						</a></li>
						<li><a href="javascript:void(0)"> <i
								class="menu-icon fa fa-user bg-yellow"></i>

								<div class="menu-info">
									<h4 class="control-sidebar-subheading">Frodo Updated His
										Profile</h4>

									<p>New phone +1(800)555-1234</p>
								</div>
						</a></li>
						<li><a href="javascript:void(0)"> <i
								class="menu-icon fa fa-envelope-o bg-light-blue"></i>

								<div class="menu-info">
									<h4 class="control-sidebar-subheading">Nora Joined Mailing
										List</h4>

									<p>nora@example.com</p>
								</div>
						</a></li>
						<li><a href="javascript:void(0)"> <i
								class="menu-icon fa fa-file-code-o bg-green"></i>

								<div class="menu-info">
									<h4 class="control-sidebar-subheading">Cron Job 254
										Executed</h4>

									<p>Execution time 5 seconds</p>
								</div>
						</a></li>
					</ul>
					<!-- /.control-sidebar-menu -->

					<h3 class="control-sidebar-heading">Tasks Progress</h3>
					<ul class="control-sidebar-menu">
						<li><a href="javascript:void(0)">
								<h4 class="control-sidebar-subheading">
									Custom Template Design <span
										class="label label-danger pull-right">70%</span>
								</h4>

								<div class="progress progress-xxs">
									<div class="progress-bar progress-bar-danger"
										style="width: 70%"></div>
								</div>
						</a></li>
						<li><a href="javascript:void(0)">
								<h4 class="control-sidebar-subheading">
									Update Resume <span class="label label-success pull-right">95%</span>
								</h4>

								<div class="progress progress-xxs">
									<div class="progress-bar progress-bar-success"
										style="width: 95%"></div>
								</div>
						</a></li>
						<li><a href="javascript:void(0)">
								<h4 class="control-sidebar-subheading">
									Laravel Integration <span
										class="label label-warning pull-right">50%</span>
								</h4>

								<div class="progress progress-xxs">
									<div class="progress-bar progress-bar-warning"
										style="width: 50%"></div>
								</div>
						</a></li>
						<li><a href="javascript:void(0)">
								<h4 class="control-sidebar-subheading">
									Back End Framework <span class="label label-primary pull-right">68%</span>
								</h4>

								<div class="progress progress-xxs">
									<div class="progress-bar progress-bar-primary"
										style="width: 68%"></div>
								</div>
						</a></li>
					</ul>
					<!-- /.control-sidebar-menu -->

				</div>
				<!-- /.tab-pane -->

				<!-- Settings tab content -->
				<div class="tab-pane" id="control-sidebar-settings-tab">
					<form method="post">
						<h3 class="control-sidebar-heading">General Settings</h3>

						<div class="form-group">
							<label class="control-sidebar-subheading"> Report panel
								usage <input type="checkbox" class="pull-right" checked>
							</label>

							<p>Some information about this general settings option</p>
						</div>
						<!-- /.form-group -->

						<div class="form-group">
							<label class="control-sidebar-subheading"> Allow mail
								redirect <input type="checkbox" class="pull-right" checked>
							</label>

							<p>Other sets of options are available</p>
						</div>
						<!-- /.form-group -->

						<div class="form-group">
							<label class="control-sidebar-subheading"> Expose author
								name in posts <input type="checkbox" class="pull-right" checked>
							</label>

							<p>Allow the user to show his name in blog posts</p>
						</div>
						<!-- /.form-group -->

						<h3 class="control-sidebar-heading">Chat Settings</h3>

						<div class="form-group">
							<label class="control-sidebar-subheading"> Show me as
								online <input type="checkbox" class="pull-right" checked>
							</label>
						</div>
						<!-- /.form-group -->

						<div class="form-group">
							<label class="control-sidebar-subheading"> Turn off
								notifications <input type="checkbox" class="pull-right">
							</label>
						</div>
						<!-- /.form-group -->

						<div class="form-group">
							<label class="control-sidebar-subheading"> Delete chat
								history <a href="javascript:void(0)" class="text-red pull-right"><i
									class="fa fa-trash-o"></i></a>
							</label>
						</div>
						<!-- /.form-group -->
					</form>
				</div>
				<!-- /.tab-pane -->
			</div>
		</aside>
		<!-- /.control-sidebar -->
		<!-- Add the sidebar's background. This div must be placed
       immediately after the control sidebar -->
		<div class="control-sidebar-bg"></div>

	</div>
	<!-- ./wrapper -->

	<div class="modal modal-info fade" id="modal-info">
		<div class="modal-dialog">
			<div class="modal-content">
				<div class="modal-header">
					<button type="button" class="close" data-dismiss="modal"
						aria-label="Close">
						<span aria-hidden="true">&times;</span>
					</button>
					<h4 class="modal-title">添加演员信息</h4>
				</div>
				<div class="modal-body">
					<div class="form-group">
						<label for="fname">first name</label> <input type="text"
							name="first_name" class="form-control" id="fname2" />
					</div>
					<div class="form-group">
						<label for="lname">last name</label> <input type="text"
							name="last_name" class="form-control" id="lname2" />
					</div>
					<div class="form-group">
						<label for="lupdate">last update</label> <input type="text"
							name="last_update" class="form-control" id="lupdate2" /> <input
							type="hidden" id="actorid" name="id2" />
					</div>

				</div>
				<div class="modal-footer">
					<button type="button" class="btn btn-outline pull-left"
						data-dismiss="modal">Close</button>
					<button type="button" id="insertactor" class="btn btn-outline">Save changes</button>
				</div>
			</div>
			<!-- /.modal-content -->
		</div>
		<!-- /.modal-dialog -->
	</div>
	<!-- /.modal -->
	
	<div class="modal modal-info fade" id="excel-info">
		<div class="modal-dialog">
			<div class="modal-content">
				<div class="modal-header">
					<button type="button" class="close" data-dismiss="modal"
						aria-label="Close">
						<span aria-hidden="true">&times;</span>
					</button>
					<h4 class="modal-title">批量导入演员Excel数据</h4>
				</div>
				<div class="modal-body">
					<div class="form-group">
						<label for="fname">下载导入模板</label> 
						<a class="btn btn-sm btn-warning btn-flat" href="data.xlsx">excel.xlsx</a>
					</div>
					<div class="form-group">
						<div class="form-group">
				    		<label for="fileupload">Excel文件</label>
				    		<input type="file" name="uploadfile"  id="fileupload"/>
				  		</div>
					</div>
				</div>
				<div class="modal-footer">
					<button type="button" class="btn btn-outline pull-left"
						data-dismiss="modal">Close</button>
					<button type="button" id="importExcel" class="btn btn-outline">import</button>
				</div>
			</div>
			<!-- /.modal-content -->
		</div>
		<!-- /.modal-dialog -->
	</div>
	<!-- /.modal -->
	
	<div class="modal modal-warning fade actormodal">
		<div class="modal-dialog">
			<div class="modal-content">
				<div class="modal-header">
					<button type="button" class="close" data-dismiss="modal"
						aria-label="Close">
						<span aria-hidden="true">&times;</span>
					</button>
					<h4 class="modal-title">修改演员信息</h4>
				</div>
				<div class="modal-body">
			        <div class="form-group">
			    		<label for="fname">first name</label>
			    		<input type="text" name="first_name" class="form-control" id="fname"/>
			  		</div>
			        <div class="form-group">
			    		<label for="lname">last name</label>
			    		<input type="text" name="last_name" class="form-control" id="lname"/>
			  		</div>
			  		<div class="form-group ">
			    		<label for="lupdate">last update</label>
			    		<input type="text" name="last_update" class="form-control" id="lupdate"/>
			    		<input type="hidden" id="actorid" name="id" />
			  		</div>
				</div>
				<div class="modal-footer">
					<button type="button" class="btn btn-outline pull-left"
						data-dismiss="modal">Close</button>
					<button type="button" id="updateactor" class="btn btn-outline">Update changes</button>
				</div>
			</div>
			<!-- /.modal-content -->
		</div>
		<!-- /.modal-dialog -->
	</div>
	<!-- /.modal -->

	<div class="modal modal-success fade" id="modal-success">
          <div class="modal-dialog">
            <div class="modal-content">
              <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                  <span aria-hidden="true">&times;</span></button>
                <h4 class="modal-title">提示</h4>
              </div>
              <div class="modal-body">
                <p>操作成功</p>
              </div>
              <div class="modal-footer">
                <button type="button" class="btn btn-outline pull-left" data-dismiss="modal">Close</button>
              </div>
            </div>
            <!-- /.modal-content -->
          </div>
          <!-- /.modal-dialog -->
        </div>
        <!-- /.modal -->

	<!-- jQuery 3 -->
	<script src="bower_components/jquery/dist/jquery.min.js"></script>
	<!-- Bootstrap 3.3.7 -->
	<script src="bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
	<!-- FastClick -->
	<script src="bower_components/fastclick/lib/fastclick.js"></script>
	<!-- AdminLTE App -->
	<script src="dist/js/adminlte.min.js"></script>
	<!-- Sparkline -->
	<script
		src="bower_components/jquery-sparkline/dist/jquery.sparkline.min.js"></script>
	<!-- jvectormap  -->
	<script src="plugins/jvectormap/jquery-jvectormap-1.2.2.min.js"></script>
	<script src="plugins/jvectormap/jquery-jvectormap-world-mill-en.js"></script>
	<!-- bootstrap datepicker -->
	<script src="bower_components/bootstrap-datepicker/dist/js/bootstrap-datepicker.min.js"></script>
	<!-- SlimScroll -->
	<script
		src="bower_components/jquery-slimscroll/jquery.slimscroll.min.js"></script>
	<!-- ChartJS -->
	<script src="bower_components/chart.js/Chart.js"></script>
	<!-- bootgrid -->
	<script src="dist/js/jquery.bootgrid.min.js"></script>
	<script src="dist/js/axios.min.js"></script>
	<!-- AdminLTE for demo purposes -->
	<script src="dist/js/demo.js"></script>
	<script type="text/javascript">
	function downloadByPost() {
        axios({ // 用axios发送post请求
            method: 'post',
            url: 'exportactor', // 请求地址
            data: {"first_name":"test","last_name":"多对多"},
            responseType: 'blob' // 表明返回服务器返回的数据类型
        }).then((resp) => { // 处理返回的文件流
                if (!resp) {
                    return
                }
                let url = window.URL.createObjectURL(new Blob([resp.data])) // 这里一定要使用resp.data的内容，否则excel中的内容为: [object][object], 而非实际的模板内容
                let link = document.createElement('a')
                link.style.display = 'none'
                link.href = url
                link.setAttribute('download', 'excel.xlsx')
                document.body.appendChild(link)
                link.click()
            });
	}
  $(document).ready(function(){
  	$("#insertactor").click(function(){
  		var json={"first_name":$("#fname2").val(),"last_name":$("#lname2").val(),"last_update":$("#lupdate2").val()};
		   $.ajax({  
            url : "/actors",  
            type : "POST",  
            data : JSON.stringify(json), //转JSON字符串  
            dataType: 'json',  
            contentType:'application/json;charset=UTF-8', //contentType很重要     
            success : function(result) {  
                //alert("添加成功"+JSON.stringify(result));  
                $("#modal-info").modal("hide");
                $("#modal-success").modal();
            }  
  	
  	});
  });
  
  $("#updateactor").click(function(){
  		var json={"actor_id":$("#actorid").val(),"first_name":$("#fname").val(),"last_name":$("#lname").val(),"last_update":$("#lupdate").val()};
		   $.ajax({  
            url : "/actors",  
            type : "PUT",  
            data : JSON.stringify(json), //转JSON字符串  
            dataType: 'json',  
            contentType:'application/json;charset=UTF-8', //contentType很重要     
            success : function(result) {  
                $(".actormodal").modal("hide");
                $("#grid-data").bootgrid("reload");
                $("#modal-success").modal();
            }  
  	
  	});
  }); 
  
  
 var grid =$("#grid-data").bootgrid({
    ajax:true,
    url:"/actors",
    navigation:2,
    ajaxSettings: {
        method: "GET",
        cache: false
    },
        formatters: {
        "commands": function(column, row)
        {
            return "<button type=\"button\" class=\"btn btn-xs btn-default command-edit\" data-row-id=\"" + row.actor_id + "\">编辑<span class=\"glyphicon glyphicon-pencil\"></span></button> "
            +"<button type=\"button\" class=\"btn btn-xs btn-default command-delete\" data-row-id=\'" + row.actor_id + "\'>删除<span class=\"glyphicon glyphicon-trash\"></span></button> "; 
        }
    	}
    }).on("loaded.rs.jquery.bootgrid", function()
	{
    /* Executes after data is loaded and rendered */
	    grid.find(".command-edit").on("click", function(e)
	    {
	        $(".actormodal").modal();
	        $.get("/actors/"+$(this).data("row-id"),function(str){
	        	$("#fname").val(str.first_name);
	        	$("#lname").val(str.last_name);
	        	$("#lupdate").val(str.last_update);
	        	$("#actorid").val(str.actor_id);
	        });
	    }).end().find(".command-delete").on("click", function(e)
		    {
		        $.ajax({  
			        url : "/actors/"+$(this).data("row-id"),  
			        type : "DELETE",  
			        success : function(result) { 
			        	alert("删除成功");
		        		$("#grid-data").bootgrid("reload");
		        		}
		    	});
		    	});
		    	});
  
 
  		$("#add").click(function(){
  	 		$(".addmodal").modal();
  	 	});
  	 	
  	 	$.get("/currentuser",function(data){
        	$(".username").text(data.msg);
    	});
    	
    	$("#importExcel").click(function(){
    		var formData = new FormData();  
		    formData.append("uploadfile", $("#fileupload")[0].files[0]);  //上传一个files对象
		    $.ajax({//jQuery方法，此处可以换成其它请求方式
		        url: '/importactor',
		        type: "post",
		        data: formData, 
		        processData: false,//不去处理发送的数据
		        contentType: false,//不去设置Content-Type请求头
		        error: function (res) {
		            alert("导入失败");
		            return;
		        },
		        success: function (res) {
		            alert("导入成功");
		            return;
		        }
        
    })
    	});
  	 	
  	 	 //Date picker
	    $('#lupdate2').datepicker({
	      autoclose: true,
	      format: "yyyy-mm-dd"
	    });
	    
	    $('#lupdate').datepicker({
	      autoclose: true,
	      format: "yyyy-mm-dd"
	    });
  	 	
  });
 

  </script>
</body>
</html>
